load data
characterset  UTF8 
--infile ''
append into table I_AAA_BILL
fields terminated by X'09' --一个tab，分隔符
TRAILING NULLCOLS (
USERNAME,
REALMNAME,
STARTTIME	date 'YYYY-MM-DD HH24:MI:SS',
STOPTIME	date 'YYYY-MM-DD HH24:MI:SS',
TIMELEN,
OUTOCTETS,
INOCTETS,
OUTPACKETS,
INPACKETS,
NASIP,
NASPORT,
NASPORTTYPE,
BINDATTR,
MACK,
SESSIONID,
IDENTIFIER,
ROAMFLAG,
DOWNREASON,
FRAMEIP,
SERVICETYPE,
AREANO,
ID "SEQ_I_AAA_BILL.NEXTVAL"  --使用序列，序列放在最后一列进行自动添加
)

--sqlldr userid=obasdev/obasdev@DB control='D:\solution\obas_yunnantelecom\integration_aaa\AAA接口全量文件\det.ctl' data='D:\solution\obas_yunnantelecom\integration_aaa\AAA接口全量文件\det_201305132121.txt' log='D:\solution\obas_yunnantelecom\integration_aaa\AAA接口全量文件\det.log' parallel=true
